-- @author lixiyong01
-- @date 2023.02.14
-- [已下线]

using hdp_lbg_supin_zplisting;

DROP TABLE IF EXISTS dwd_zp_n_bcp_check_detail;
CREATE TABLE hdp_lbg_supin_zplisting.dwd_zp_n_bcp_check_detail (
    `recsid` string COMMENT '招聘推荐sid',
    `pid` string COMMENT '每次页面请求的ID',
    `slot` string COMMENT '推荐位标识',
    `row_key` string COMMENT '异常记录拼接的(ptype-pageno-requesttype-business_type-ad_lego_tid)',
    `reason` string COMMENT '异常原因',
    `abtest` string COMMENT '本次检索请求服务ab测标识',
    `platform` int COMMENT '展现平台:[1-pc，2-m，3-app]',
    `os` string COMMENT '操作系统:[android,ios,-]',
    `versioncode` string COMMENT 'app版本号',
    `zpsrc` string COMMENT '业务板块'
) comment '数据检查异常结果详情'
PARTITIONED BY (dt string, rid string comment '规则ID', servertype string comment '数据渠道')
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ','
STORED AS ORCFILE;

